﻿CREATE TABLE [dbo].[Questao] (
    [Id]                 INT           IDENTITY (1, 1) NOT NULL,
    [IdQuestionario]     INT           NOT NULL,
    [Descricao]          VARCHAR (255) NOT NULL,
    [AlternativaA]       VARCHAR (100) NULL,
    [AlternativaB]       VARCHAR (100) NULL,
    [AlternativaC]       VARCHAR (100) NULL,
    [AlternativaD]       VARCHAR (100) NULL,
    [Ativo]              BIT           DEFAULT ('1') NOT NULL,
    [Tempo]              INT           NULL,
    [AlternativaCorreta] INT           NULL,
    [Imagem]             VARCHAR (255) NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF),
    FOREIGN KEY ([IdQuestionario]) REFERENCES [dbo].[Questionario] ([Id]) ON DELETE NO ACTION ON UPDATE NO ACTION
);





